SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = object_id('dbo.lib_fetch_card'))
	DROP PROCEDURE dbo.lib_fetch_card
GO

CREATE PROCEDURE dbo.lib_fetch_card
	@card_no nvarchar(20)

AS
BEGIN
	SET NOCOUNT ON;

	SELECT * FROM card WHERE card_no = @card_no;


END